package cggl;

import java.util.List;
import com.jfinal.plugin.activerecord.Model;
/**
 * 采购计划子表
 * @author cheng
 * @date 2017.8.22
 * @version 1.0
 */
@SuppressWarnings("serial")
public class Cgjha extends Model<Cgjha> {

	public static final Cgjha dao=new Cgjha();
	public static String ALLCOLUMN = "id,cgjhh,xqdh,xqr,xqxdsj,xqwcsj,cgkssj,cgjssj,cgqrrq,cgqr,cpbm,wlbm,wlmc,ggxh,cglx,xqsl,yt,cgy,gcdm,bz";

	/**
	 * 获取采购订单子表信息
	 * @param 
	 * @return
	 */
	public List<Cgjha> getCgList(String xqdh){
		return dao.find("SELECT "+ALLCOLUMN+" FROM cgjha WHERE xqdh="+"'"+xqdh+"'");
	}
}